Setting Check Properties

Use the Check Name edit box to set the check name.

Check Expression
Set the logical expression that returns TRUE or FALSE, e.g. "field_name1 > 0 AND field_name2 > field_name1" in the Check Expression edit box.

Not for Replication
The constraint is not enforced when replication agents perform insert, update, or delete operations.

Note: SQL Azure does not support.

Enable
You can choose whether to enable / disable the check constraint by checking / unchecking the box.

Check Comment
Specify the comment of the check.

Note: SQL Azure does not support.